home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d16
/
sam210.arc
/
SAM210.DOC
< prev
Wrap
Text File
|
1991-04-27
|
7KB
|
162 lines
"SaveAsMac" (C) Copyright 1991 by Stephen L. Jenkins.
All right reserved.
Version : 2.10 - 4/28/1991
===================================================================
This Excel Spreadsheet macro replaces five of the standard
file menu options having to do with opening and closing files.
The five options are activated through the use of the
keyboard, so they do not replace the default menus in any way.
NEW===NEW===NEW===NEW===NEW
SAM can now be configured to take over Excel's menus and hotkeys.
See configuring SAM, below.
NEW===NEW===NEW===NEW===NEW
All options are activated by holding down the [Ctrl] and [Alt]
keys and then pressing the letter for the option you want. The
letters are not case sensitive.
The letter options are:
[N] - to open a new Work/Macro/Chart sheet
[O] - to open a file
[S] - saves the current file
[A] - saves current file with new name or format
[C] - closes the current file
NEW SHEET - [Ctrl]+[Alt]+[N]
This brings up the default new sheet dialog box. Except that the
highlight bar always starts on Worksheet.
OPEN FILE - [Ctrl]+[Alt]+[O]
This dialog is new from the ground up, so read this or just play
to get used to it. The 'Last opened files' list is just that; it
tracks files(up to 19) that you have opened with SAM(NOTE: the reason
that Excel doesn't track the files opened by SAM is due to an
acknowledged limitation in the OPEN macro command.) and makes it easier
to select commonly opened files, rather than searching through directories.
The 'type' list makes it easy to select what kinds of files you want
the files list box to display. It also effects 'Text data . . .'
items at the bottom of the dialog. Text data is only available if
you select CSV or Text as the file type. The 'Read only' check box
will open the file in read-only mode. The 'Auto_Open' check box
selects whether Auto_Open macros are run when you open a macro sheet.
The little copyright button will bring up a small 'about' box(can be
invoked with Alt-C).
SAVE FILE - [Ctrl]+[Alt]+[S]
This option saves the current file and works the same as the
File-Save menu option in Excel. The real advantage of this macro
is that you can make very quick work of saving a file. If the current
sheet is being saved for the first time, the SAVE AS dialog box will
be displayed(nice to see this added to Excel 3.0).
SAVE AS - [Ctrl]+[Alt]+[A]
Well it was great to see that with Excel 3.0, MS finally gave us
the ability to change directories with the SaveAs dialog, but what is
still sorely missing is the ability to see the files in the target
directory. I don't know about you but I'm always forgetting the last
name in a sequence of names(i.e. bdgt01.xls, bdgt02.xls...) and seeing
the names helps a lot. The file sharing options are only available with
certain file formats. If the 'Close' check box is checked the document
will be closed after it is saved. The 'Backup' check box controls whether
a backup copy of the file is made. Again, the little copyright button will
bring up a small 'about' box.
CLOSE - [Ctrl]+[Alt]+[C]
This option now does the same close as the File.Close menu option.
(i.e. You will be prompted if there is unsaved work.)
**** KEYBOARD USERS NOTE ****
Using the combo-boxes with the keyboard can be a little tricky, so a
short tutorial is provided. Start Excel w/ SAM and bring up the OPEN
dialog(press Ctrl+Alt+O). When the dialog is visible press Alt+E. The
'type' combo-box is activated. If you want to expand the list press
Alt+down cursor key. Now PRESS AND HOLD the Ctrl key. Using
the up/down cursor keys select the item you want. When it is in the
selection bar press the spacebar, this will select that item. Play
around, it gets easier.
------------------------------------------------------------------
INSTALLING
SAM.XLM should be placed in the XLSTART directory, so that it will
load automatically. When it is opened you will not see any difference
in Excel. The only way to see if SAM.XLM is loaded is to check the
"File_Unhide Window or Window-Unhide Window" menu options and it should
be listed as a hidden window. You can't unhide this window, so don't even try.
CONFIGURATION
SAM can be configured to take over the Excel menus and hotkeys.
To do this follow these instructions.
1) Copy SAM.XLM in your XLSTART directory.
2) Start Excel.
3) Check to make sure SAM was loaded by pressing [Ctrl]+[Alt]+O.
If it was loaded you should see SAM's OPEN FILE dialog.
Press [Esc].
4) Quit Excel. When you do this SAM will write a SAM.INI file to
your Excel directory. This file contains the control option and
the file list.
5) Now open Notepad and load SAM.INI from your Excel directory. At the
top of the file you will see a section labeled [Controls]. The entry
under the heading will be "Control=SAM". With this setting SAM uses
its own hotkeys as the access method. If you change the line to
read "Control=Excel" then SAM will use Excel's menus and hotkeys
as the access method.
Once you have edited and saved SAM.INI with the "Control=Excel"; the
next time you start Excel you should notice that the ellipsis on certain
of the file menu options are wider spaced. This will let you know
that SAM has taken over these options.
UNLOADING
In this version there is no way to unload SAM.XLM other than closing
Excel and removing SAM.XLM from the XLSTART directory.
QUITTING EXCEL
When quitting Excel SAM will create a SAM.INI file in your Excel directory.
This is where the configuration option and file list are saved.
------------------------------------------------------------------
LEGAL STUFF
This macro is Freeware and as such may not be sold for any amount.
So there! It may be freely distributed as long as this document(SAM.DOC)
remains unaltered and is distributed with SAM.XLM.
-------------------------------------------------------------------
AUTHOR
If you have any questions or comments about this macro I can be reached
through Compuserve. ID# 76666,1066
-------------------------------------------------------------------
VERSION HISTORY
1.20 - 3/16/89 - Initial release.
1.30 - 1/12/91 - Second release.
Added Ctrl+Atl+N for new sheet.
Fixed non-execution problem with Auto_Exec macros.
Reworked macro to reduce size.
2.00 - 2/21/91 - Third release.
Complete rewrite to fix all the things that broke
under Excel 3.0, and to add support for all the new
file formats.
2.10 - 4/28/91 - Fourth release.
Added option to replace Excel's menus & hotkeys.
Added SAM.INI to hold configuration info.
Reworked exit routine to speed it up.
Sorry it's a bit bigger. Next release will address this.
-------------------------------------------------------------------
Enjoy.
Stephen Jenkins
T/S macroware
4/28/91